SELECT T.* ,DECODE (
  (SELECT COUNT(1) FROM FD_SITE_DE SSD WHERE SSD.ENTITY_ID = T.ID
  ),0,'false','true' ) AS DEFAULT_CO
FROM FD_SITE T
WHERE T.ID = :ID